IF EXISTS (SELECT * from dbo.sysobjects WHERE id = object_id(N'[dbo].[SelectCuentaByIdBanco]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[SelectCuentaByIdBanco]
GO

CREATE PROCEDURE [dbo].[SelectCuentaByIdBanco]
(
	@IdBanco int
)
AS
BEGIN
	SET NOCOUNT ON

	SELECT
	[IdCuenta],
	[IdBanco],
	[Numero],
	[Tipo]
	FROM [Cuenta]
	WHERE [IdBanco] = @IdBanco

	SET NOCOUNT OFF
END

GO
